ListValueCountNoCase(list, value [, delimiters ])


Returns the number of instances of a specified value in a list. The underlying search that finds the instances is not case-sensitive.

See also ListToArray.

list

A list or the name of a list that is to be searched.

value

The string or number that the function is to find and count.

delimiter

Optional. Specify the character(s) used to delimit elements in the list. The default is a comma ( , ).